USE [CTEM-DB-v1]
GO

/****** Object:  StoredProcedure [dbo].[Ledger_GetforReport]    Script Date: 02/10/2012 11:19:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Hainh	
-- Create date: 09/02/2011
-- =============================================
CREATE PROCEDURE [dbo].[Ledger_GetforReport]
            @Type            nvarchar(50),
            @Kind            bigint,
            @Formday         datetime,
            @ToDay           datetime
AS
BEGIN
	 SELECT*
	 From Ledger V
	 Where V.Kind = @Kind
	       and V.Type like @Type
	       and V.Date >= @Formday
	       and V.Date <= @ToDay
	
END

GO

